|
This filter selects an XML-delimited field for further processing, such as a
search/replace inside it, or a
case conversion
etc.
For example, if your data looked like this, and you wanted to
UPPERCASE the CompanyName
field:
<TextPipeRow>
<CustomerID>ALFKI</CustomerID>
<CompanyName>Alfreds Futterkiste</CompanyName>
<ContactName>Maria Anders</ContactName>
<ContactTitle>Sales Representative</ContactTitle>
<Address>Obere Str. 57</Address>
<City>Berlin</City>
<Region></Region>
<PostalCode>12209</PostalCode>
<Country>Germany</Country>
<Phone>030-0074321</Phone>
<Fax>030-0076545</Fax>
</TextPipeRow>
Specify the 'Restrict to tag' name to select as 'CompanyName'. Then use a
sub filter of
UPPERCASE. The resulting
output looks like this:
<TextPipeRow>
<CustomerID>ALFKI</CustomerID>
<COMPANYNAME>ALFREDS FUTTERKISTE</COMPANYNAME>
<ContactName>Maria Anders</ContactName>
<ContactTitle>Sales Representative</ContactTitle>
<Address>Obere Str. 57</Address>
<City>Berlin</City>
<Region></Region>
<PostalCode>12209</PostalCode>
<Country>Germany</Country>
<Phone>030-0074321</Phone>
<Fax>030-0076545</Fax>
</TextPipeRow>
Note - if you want to change text inside the XML tag itself, use a
Find text inside an HTML tag
filter.
See also
Sub
filters
Restrict to delimited fields (CSV, Tab, Pipe etc)
|